['База знаний', 'Статьи, разборы, методики'], 'cases' => ['Кейсы', 'Инженерные расследования'], 'faults' => ['Каталог неисправностей', 'Оборудование, симптомы, диагностика'], 'templates' => ['Шаблоны документов', 'Акты, ведомости, журналы'], 'checklists' => ['Чек-листы', 'Проверки и формы для скачивания'], ]; // Запасные функции, если на хостинге нет расширения mbstring if (!function_exists('mb_strlen')) { function mb_strlen(string $s): int { return (int)preg_match_all('/./us', $s); } } if (!function_exists('mb_substr')) { function mb_substr(string $s, int $a, ?int $l = null): string { preg_match_all('/./us', $s, $m); return implode('', array_slice($m[0], $a, $l)); } } const PER_PAGE = 12; const VISIBLE = 'm.published=1 AND (m.publish_date IS NULL OR m.publish_date<=NOW())'; function e(?string $s): string { return htmlspecialchars((string)$s, ENT_QUOTES | ENT_SUBSTITUTE, 'UTF-8'); } function db(): PDO { static $p = null; if (!$p) $p = new PDO(DB_DSN, DB_USER, DB_PASS, [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, PDO::ATTR_EMULATE_PREPARES => true, ]); return $p; } function q(string $sql, array $a = []): array { $s = db()->prepare($sql); $s->execute($a); return $s->fetchAll(); } function dt(array $r): string { return (string)($r['publish_date'] ?: $r['created_at']); } function cut(string $s, int $n): string { $s = trim(preg_replace('/\s+/u', ' ', strip_tags($s))); return mb_strlen($s) > $n ? mb_substr($s, 0, $n - 1) . '…' : $s; } function layout(string $title, string $desc, string $body, string $path, array $o = []): void { $canon = SITE_URL . $path; $t = e($title . ' — ' . SITE_NAME); echo ''; echo "$t"; if (!empty($o['keywords'])) echo ''; if (!empty($o['noindex'])) echo ''; echo "'; if (!empty($o['image'])) echo ''; echo ''; if (!empty($o['ld'])) echo ''; echo '
' . $body . '
'; echo ''; } function not_found(): void { http_response_code(404); layout('Страница не найдена', 'Страница не найдена', '

Страница не найдена

Возможно, материал ещё не опубликован или адрес изменился.

На главную

', '/404', ['noindex' => 1]); } function list_page(string $sec): void { [$name, $sub] = SECTIONS[$sec]; $cat = (string)($_GET['cat'] ?? ''); $qs = trim((string)($_GET['q'] ?? '')); $pg = max(1, (int)($_GET['p'] ?? 1)); $w = ['m.section=:s', VISIBLE]; $a = ['s' => $sec]; if ($cat !== '') { $w[] = 'c.slug=:c'; $a['c'] = $cat; } if ($qs !== '') { $w[] = '(m.title LIKE :q OR m.excerpt LIKE :q OR m.meta_keywords LIKE :q OR m.brand LIKE :q OR m.series LIKE :q)'; $a['q'] = '%' . $qs . '%'; } $from = 'FROM materials m LEFT JOIN categories c ON c.id=m.category_id WHERE ' . implode(' AND ', $w); $total = (int)q("SELECT COUNT(*) n $from", $a)[0]['n']; $rows = q("SELECT m.title,m.slug,m.excerpt,m.brand,m.series,m.file_format,m.is_training,c.name cat $from ORDER BY COALESCE(m.publish_date,m.created_at) DESC,m.id DESC LIMIT " . PER_PAGE . ' OFFSET ' . (($pg - 1) * PER_PAGE), $a); $cats = q('SELECT slug,name FROM categories WHERE section=:s ORDER BY sort,name', ['s' => $sec]); $b = '

Главная / ' . e($name) . '

' . e($name) . '

' . e($sub) . '

'; $b .= '
'; $b .= '
'; if (!$rows) $b .= '

Пока ничего не опубликовано.

'; $b .= '
'; foreach ($rows as $r) { $k = array_filter([$r['cat'], trim($r['brand'] . ' ' . $r['series']), $r['file_format'] ? strtoupper($r['file_format']) : '', $r['is_training'] ? 'учебный сценарий' : '']); $b .= '

' . e(implode(' · ', $k)) . '

' . e($r['title']) . '

' . e(cut((string)$r['excerpt'], 200)) . '

'; } $b .= '
'; $pages = (int)ceil($total / PER_PAGE); if ($pages > 1) { $b .= '
'; for ($i = 1; $i <= $pages; $i++) $b .= $i === $pg ? "$i" : '$i"; $b .= '
'; } layout($name, $sub, $b, '/' . $sec . '/', ['noindex' => ($qs !== '' || $cat !== '' || $pg > 1)]); } function detail_page(string $sec, string $slug): void { $r = q('SELECT m.*,c.name cat,a.name author FROM materials m LEFT JOIN categories c ON c.id=m.category_id LEFT JOIN authors a ON a.id=m.author_id WHERE m.section=:s AND m.slug=:l AND ' . VISIBLE, ['s' => $sec, 'l' => $slug]); if (!$r) { not_found(); return; } $r = $r[0]; $name = SECTIONS[$sec][0]; $path = '/' . $sec . '/' . $slug; $desc = $r['meta_description'] ?: cut((string)$r['excerpt'], 160); $b = '

Главная / ' . e($name) . '

'; $b .= '

' . e(implode(' · ', array_filter([$r['cat'], $r['is_training'] ? 'учебный сценарий' : '', trim($r['brand'] . ' ' . $r['series'])]))) . '

'; $b .= '

' . e($r['title']) . '

'; if ($r['excerpt']) $b .= '

' . e($r['excerpt']) . '

'; $b .= '
' . e(substr(dt($r), 0, 10)) . '' . ($r['author'] ? '' . e($r['author']) . '' : '') . '
'; if ($r['is_training']) $b .= '
Это учебный сценарий, а не выполненный проект. Клиенты и данные вымышлены.
'; if ($r['file_url']) $b .= '

Скачать' . ($r['file_format'] ? ' ' . e(strtoupper($r['file_format'])) : '') . '

'; $b .= '
' . $r['content'] . '
'; // HTML вставляете вы сами, наружу формы нет $b .= '

Нужна диагностика или документы?

Опишите неисправность. Обязательных полей нет.

Описать неисправность
'; $rel = q('SELECT m.title,m.slug FROM materials m WHERE m.section=:s AND m.slug<>:l AND ' . VISIBLE . ' ORDER BY COALESCE(m.publish_date,m.created_at) DESC LIMIT 3', ['s' => $sec, 'l' => $slug]); if ($rel) { $b .= '

Ещё в разделе

'; } $ld = ['@context' => 'https://schema.org', '@type' => 'Article', 'headline' => $r['title'], 'description' => $desc, 'datePublished' => dt($r), 'dateModified' => (string)$r['updated_at'], 'mainEntityOfPage' => SITE_URL . $path, 'publisher' => ['@type' => 'Organization', 'name' => SITE_NAME]]; if ($r['author']) $ld['author'] = ['@type' => 'Person', 'name' => $r['author']]; if ($r['image_url']) $ld['image'] = $r['image_url']; layout($r['title'], $desc, $b, $path, ['keywords' => $r['meta_keywords'], 'image' => $r['image_url'], 'ld' => $ld]); } function sitemap(): void { header('Content-Type: application/xml; charset=utf-8'); echo ''; echo '' . e(SITE_URL . '/') . ''; foreach (SECTIONS as $k => $v) echo '' . e(SITE_URL . "/$k/") . ''; foreach (q('SELECT m.section,m.slug,m.updated_at FROM materials m WHERE ' . VISIBLE . ' ORDER BY m.id') as $r) echo '' . e(SITE_URL . '/' . $r['section'] . '/' . $r['slug']) . '' . e(substr((string)$r['updated_at'], 0, 10)) . ''; echo ''; } function latest(): void { header('Content-Type: application/json; charset=utf-8'); header('Cache-Control: public, max-age=300'); $out = []; foreach (q('SELECT m.section,m.title,m.slug,m.excerpt FROM materials m WHERE ' . VISIBLE . ' ORDER BY COALESCE(m.publish_date,m.created_at) DESC,m.id DESC LIMIT 6') as $r) $out[] = ['section' => SECTIONS[$r['section']][0] ?? '', 'title' => $r['title'], 'url' => '/' . $r['section'] . '/' . $r['slug'], 'excerpt' => cut((string)$r['excerpt'], 140)]; echo json_encode($out, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES); } $path = trim((string)parse_url($_SERVER['REQUEST_URI'] ?? '/', PHP_URL_PATH), '/'); $p = $path === '' ? [] : explode('/', $path); try { if ($path === 'sitemap.xml') sitemap(); elseif ($path === 'api/latest.json') latest(); elseif (isset($p[0], SECTIONS[$p[0]]) && count($p) === 1) list_page($p[0]); elseif (isset($p[0], SECTIONS[$p[0]]) && count($p) === 2 && preg_match('/^[a-z0-9-]{1,190}$/', $p[1])) detail_page($p[0], $p[1]); else not_found(); } catch (Throwable $ex) { error_log((string)$ex); http_response_code(500); layout('Ошибка', 'Временная ошибка', '

Временная ошибка

Попробуйте обновить страницу позже.

', '/error', ['noindex' => 1]); }